/*
 Navicat Premium Data Transfer

 Source Server         : 134.175.9.55
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 134.175.9.55:3306
 Source Schema         : node_admin

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 14/06/2021 21:12:55
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for file
-- ----------------------------
DROP TABLE IF EXISTS `file`;
CREATE TABLE `file` (
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of file
-- ----------------------------
BEGIN;
INSERT INTO `file` VALUES ('2021-06-06 01:10:33', '2021-06-06 01:10:33', 1, '1622913033359.png', 'f94c5af45a6af0acb9e11bbad9313a4b.png', '/uploads/2021-06-06/1622913033359.png');
INSERT INTO `file` VALUES ('2021-06-06 17:19:19', '2021-06-06 17:19:19', 2, '1622971159488.png', 'f94c5af45a6af0acb9e11bbad9313a4b.png', '/uploads/2021-06-06/1622971159488.png');
INSERT INTO `file` VALUES ('2021-06-06 17:19:40', '2021-06-06 17:19:40', 3, '1622971180035.png', 'f94c5af45a6af0acb9e11bbad9313a4b.png', '/uploads/2021-06-06/1622971180035.png');
INSERT INTO `file` VALUES ('2021-06-06 17:59:58', '2021-06-06 17:59:58', 4, '1622973597926.png', 'f94c5af45a6af0acb9e11bbad9313a4b.png', '/uploads/2021-06-06/1622973597926.png');
COMMIT;

-- ----------------------------
-- Table structure for login_log
-- ----------------------------
DROP TABLE IF EXISTS `login_log`;
CREATE TABLE `login_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `os` varchar(255) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `ua` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `login_time` datetime DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of login_log
-- ----------------------------
BEGIN;
INSERT INTO `login_log` VALUES (1, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 01:04:33', NULL, NULL);
INSERT INTO `login_log` VALUES (2, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 04:39:31', NULL, NULL);
INSERT INTO `login_log` VALUES (3, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 04:41:19', NULL, NULL);
INSERT INTO `login_log` VALUES (4, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 04:42:40', NULL, NULL);
INSERT INTO `login_log` VALUES (5, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 04:47:14', NULL, NULL);
INSERT INTO `login_log` VALUES (6, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 04:49:33', NULL, NULL);
INSERT INTO `login_log` VALUES (7, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 04:54:36', '192.168.0.101', '本地局域网');
INSERT INTO `login_log` VALUES (8, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 16:07:39', '192.168.0.100', '本地局域网');
INSERT INTO `login_log` VALUES (9, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 16:41:40', '192.168.0.100', '本地局域网');
INSERT INTO `login_log` VALUES (10, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 17:19:55', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (11, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 17:35:34', '112.224.141.185', '山东省 联通');
INSERT INTO `login_log` VALUES (12, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 19:46:10', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (13, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 20:19:52', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (14, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 21:25:03', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (15, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 21:52:29', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (16, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-06 22:03:57', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (17, 'Windows/10', 'Chrome/89.0.4389.82', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.82 Safari/537.36', 1, '2021-06-06 23:39:05', '110.184.135.142', '四川省成都市青羊区 电信');
INSERT INTO `login_log` VALUES (18, 'Windows/10', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-07 09:29:41', '119.163.138.242', '山东省济南市 联通');
INSERT INTO `login_log` VALUES (19, 'Windows/10', 'Chrome/92.0.4515.20', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.20 Safari/537.36', 1, '2021-06-07 10:36:24', '144.123.170.94', '山东省 电信');
INSERT INTO `login_log` VALUES (20, 'Windows/10', 'Chrome/92.0.4515.20', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.20 Safari/537.36', 1, '2021-06-07 11:14:03', '144.123.170.94', '山东省 电信');
INSERT INTO `login_log` VALUES (21, 'Windows/10', 'Firefox/90.0', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:90.0) Gecko/20100101 Firefox/90.0', 1, '2021-06-07 13:37:29', '58.56.102.22', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (22, 'Windows/10', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-07 15:18:31', '119.123.204.195', '广东省深圳市南山区 电信');
INSERT INTO `login_log` VALUES (23, 'Ubuntu/undefined', 'Firefox/87.0', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0', 1, '2021-06-07 16:28:37', '36.102.208.158', '北京市北京市 电信');
INSERT INTO `login_log` VALUES (24, 'Windows/10', 'Chrome/86.0.4240.198', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 1, '2021-06-07 17:16:28', '113.110.225.200', '广东省深圳市 电信');
INSERT INTO `login_log` VALUES (25, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-07 20:21:43', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (26, 'Windows/10', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-07 21:24:41', '112.231.177.10', '山东省济南市 联通');
INSERT INTO `login_log` VALUES (27, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-07 21:59:29', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (28, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-07 23:11:04', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (29, 'Windows/10', 'Edge/91.0.864.41', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36 Edg/91.0.864.41', 1, '2021-06-08 09:42:56', '118.112.75.185', '四川省成都市 电信');
INSERT INTO `login_log` VALUES (30, 'Windows/10', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-08 10:06:51', '113.218.174.2', '湖南省常德市 电信');
INSERT INTO `login_log` VALUES (31, 'Windows/10', 'Edge/91.0.864.41', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36 Edg/91.0.864.41', 1, '2021-06-08 10:38:22', '106.84.165.49', '重庆市重庆市 电信');
INSERT INTO `login_log` VALUES (32, 'Windows/10', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-08 10:42:08', '117.136.30.22', '重庆市重庆市 移动');
INSERT INTO `login_log` VALUES (33, 'Windows/7', 'Chrome/51.0.2704.103', 'Mozilla/5.0 (HENGTIANSOFT; Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36', 1, '2021-06-08 10:51:02', '220.180.239.184', '安徽省合肥市 电信');
INSERT INTO `login_log` VALUES (34, 'Windows/10', 'Chrome/90.0.4430.93', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36', 1, '2021-06-08 10:54:53', '116.54.125.38', '云南省昆明市 电信');
INSERT INTO `login_log` VALUES (35, 'Windows/10', 'Chrome/90.0.4412.5', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4412.5 Safari/537.36', 1, '2021-06-08 12:52:12', '124.205.126.42', '北京市北京市 鹏博士宽带');
INSERT INTO `login_log` VALUES (36, 'Ubuntu/', 'Firefox/87.0', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0', 1, '2021-06-08 13:26:19', '36.102.208.158', '北京市北京市 电信');
INSERT INTO `login_log` VALUES (37, 'Windows/10', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-08 13:43:52', '171.114.48.221', '湖北省宜昌市 电信');
INSERT INTO `login_log` VALUES (38, 'Windows/10', 'Chrome/90.0.4412.5', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4412.5 Safari/537.36', 1, '2021-06-08 15:06:10', '124.205.126.42', '北京市北京市 鹏博士宽带');
INSERT INTO `login_log` VALUES (39, 'Windows/10', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-08 15:25:09', '113.91.32.192', '广东省深圳市 电信');
INSERT INTO `login_log` VALUES (40, 'Windows/10', 'Edge/91.0.864.41', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36 Edg/91.0.864.41', 1, '2021-06-08 15:43:22', '220.178.80.6', '安徽省合肥市 电信');
INSERT INTO `login_log` VALUES (41, 'Windows/10', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-08 17:36:41', '125.70.179.64', '四川省成都市 电信');
INSERT INTO `login_log` VALUES (42, 'Mac OS/10.15.7', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-08 20:09:47', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (43, 'Mac OS/10.14.6', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-08 20:35:14', '117.186.222.54', '上海市上海市 移动');
INSERT INTO `login_log` VALUES (44, 'Mac OS/11.2.1', 'Edge/88.0.705.68', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36 Edg/88.0.705.68', 1, '2021-06-08 20:38:55', '121.224.206.202', '江苏省苏州市 电信');
INSERT INTO `login_log` VALUES (45, 'Mac OS/10.15.7', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-08 21:46:25', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (46, 'Windows/10', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-09 08:52:55', '114.227.186.97', '江苏省常州市 电信');
INSERT INTO `login_log` VALUES (47, 'Windows/10', 'Chrome/92.0.4515.20', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.20 Safari/537.36', 1, '2021-06-09 10:02:14', '144.123.170.94', '山东省 电信');
INSERT INTO `login_log` VALUES (48, 'Windows/10', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-09 11:28:44', '114.218.166.93', '江苏省苏州市 电信');
INSERT INTO `login_log` VALUES (49, 'Windows/10', 'Chrome/90.0.4430.93', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36', 1, '2021-06-09 13:48:44', '171.11.146.41', '河南省洛阳市 电信');
INSERT INTO `login_log` VALUES (50, 'Windows/10', 'Chrome/92.0.4515.20', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.20 Safari/537.36', 1, '2021-06-09 14:26:17', '144.123.170.94', '山东省 电信');
INSERT INTO `login_log` VALUES (51, 'Windows/7', 'Chrome/89.0.4389.114', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36', 1, '2021-06-09 16:59:11', '120.237.147.92', '广东省佛山市 移动');
INSERT INTO `login_log` VALUES (52, 'Windows/10', 'MetaSr/', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.81 Safari/537.36 SE 2.X MetaSr 1.0', 1, '2021-06-10 03:41:57', '117.181.237.229', '广西壮族自治区南宁市 移动');
INSERT INTO `login_log` VALUES (53, 'Windows/10', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-10 09:05:15', '223.88.75.96', '河南省郑州市 移动');
INSERT INTO `login_log` VALUES (54, 'Windows/10', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-10 09:39:45', '223.94.54.184', '浙江省宁波市 移动');
INSERT INTO `login_log` VALUES (55, 'Windows/10', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-10 10:12:25', '223.94.54.184', '浙江省宁波市 移动');
INSERT INTO `login_log` VALUES (56, 'Windows/10', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-10 10:12:26', '223.94.54.184', '浙江省宁波市 移动');
INSERT INTO `login_log` VALUES (57, 'Windows/10', 'Chrome/89.0.4389.82', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.82 Safari/537.36', 1, '2021-06-10 13:10:54', '1.207.135.104', '贵州省黔西南布依族苗族自治州 电信');
INSERT INTO `login_log` VALUES (58, 'Windows/10', 'Chrome/87.0.4280.88', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36', 1, '2021-06-10 13:32:34', '124.118.155.86', '新疆维吾尔自治区喀什地区 电信');
INSERT INTO `login_log` VALUES (59, 'Windows/10', 'Chrome/90.0.4430.85', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36', 1, '2021-06-10 16:27:13', '180.114.205.240', '江苏省无锡市 电信');
INSERT INTO `login_log` VALUES (60, 'Mac OS/10.15.7', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-10 21:23:31', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (61, 'Mac OS/10.15.7', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-10 21:24:31', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (62, 'Windows/10', 'Chrome/88.0.4324.182', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36', 1, '2021-06-11 05:08:49', '36.101.25.215', '海南省海口市 电信');
INSERT INTO `login_log` VALUES (63, 'Mac OS/10.15.7', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-11 10:54:45', '61.173.28.232', '上海市闵行区 电信');
INSERT INTO `login_log` VALUES (64, 'Mac OS/10.15.7', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-11 11:14:02', '116.237.205.171', '上海市上海市 电信');
INSERT INTO `login_log` VALUES (65, 'Windows/10', 'Firefox/89.0', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:89.0) Gecko/20100101 Firefox/89.0', 1, '2021-06-11 11:26:18', '117.136.30.121', '重庆市重庆市 移动');
INSERT INTO `login_log` VALUES (66, 'Windows/10', 'Chrome/92.0.4515.20', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.20 Safari/537.36', 1, '2021-06-11 14:16:03', '144.123.170.94', '山东省 电信');
INSERT INTO `login_log` VALUES (67, 'Mac OS/10.15.7', 'Chrome/91.0.4472.101', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', 1, '2021-06-11 15:31:39', '122.226.140.70', '浙江省台州市 电信');
INSERT INTO `login_log` VALUES (68, 'Windows/10', 'Chrome/86.0.4240.198', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 1, '2021-06-11 16:13:55', '36.7.68.79', '安徽省合肥市 电信');
INSERT INTO `login_log` VALUES (69, 'Mac OS/10.15.7', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-11 20:45:29', '144.123.92.232', '山东省济南市 电信');
INSERT INTO `login_log` VALUES (70, 'Windows/10', 'Chrome/90.0.4430.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', 1, '2021-06-11 22:30:45', '218.250.244.28', '香港特别行政区');
INSERT INTO `login_log` VALUES (71, 'Windows/10', 'Chrome/91.0.4472.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', 1, '2021-06-12 09:04:58', '117.176.186.242', '四川省成都市 移动');
INSERT INTO `login_log` VALUES (72, 'Windows/10', 'Edge/91.0.864.41', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36 Edg/91.0.864.41', 1, '2021-06-12 17:21:28', '59.35.112.131', '广东省汕头市 电信');
INSERT INTO `login_log` VALUES (73, 'Windows/10', 'Chrome/90.0.4430.85', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36', 1, '2021-06-12 18:05:13', '180.91.179.54', '广东省广州市 长城宽带');
INSERT INTO `login_log` VALUES (74, 'Windows/10', 'Chrome/90.0.4430.93', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36', 1, '2021-06-13 10:35:43', '61.140.236.188', '广东省广州市 电信');
INSERT INTO `login_log` VALUES (75, 'Windows/10', 'Edge/91.0.864.41', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36 Edg/91.0.864.41', 1, '2021-06-13 11:52:05', '14.149.140.229', '广东省河源市 电信');
INSERT INTO `login_log` VALUES (76, 'Windows/10', 'Chrome/90.0.4430.85', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36', 1, '2021-06-13 16:30:48', '121.32.78.239', '广东省广州市白云区 电信');
INSERT INTO `login_log` VALUES (77, 'Windows/10', 'Edge/91.0.864.41', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36 Edg/91.0.864.41', 1, '2021-06-13 20:23:40', '112.10.81.148', '浙江省杭州市 移动');
INSERT INTO `login_log` VALUES (78, 'Windows/10', 'Edge/91.0.864.41', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36 Edg/91.0.864.41', 1, '2021-06-13 23:01:10', '58.19.94.9', '湖北省武汉市 联通');
INSERT INTO `login_log` VALUES (79, 'Mac OS/10.15.7', 'Chrome/91.0.4472.101', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', 1, '2021-06-14 13:03:54', '116.53.229.121', '云南省昆明市 电信');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `ancestors` varchar(255) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `data_status` int(11) DEFAULT NULL COMMENT '1启用,0停用,-1删除',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (1, 0, '总公司', NULL, 0, 1, '2021-06-06 01:08:59', '2021-06-06 01:08:59');
INSERT INTO `sys_dept` VALUES (2, 1, '济南分公司', 'null,1', 0, 1, '2021-06-06 01:09:19', '2021-06-06 01:09:19');
INSERT INTO `sys_dept` VALUES (3, 2, '研发部', 'null,1,2', 0, 1, '2021-06-06 01:09:31', '2021-06-06 01:09:31');
INSERT INTO `sys_dept` VALUES (4, 1, '北京分公司', 'null,1', 1, 1, '2021-06-06 01:49:56', '2021-06-06 01:49:56');
INSERT INTO `sys_dept` VALUES (5, 4, '市场部', 'null,1,4', 0, 1, '2021-06-06 01:50:09', '2021-06-06 01:50:09');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `permission` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `parent_id` int(11) NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `component` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `data_status` int(11) DEFAULT NULL,
  `is_show_menu` int(11) DEFAULT NULL,
  `createTime` datetime NOT NULL,
  `updateTime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, '系统管理', NULL, '/sysMenger', 0, 'el-icon-setting', 'layout', 1, 0, 1, 1, '2021-06-06 01:11:59', '2021-06-06 01:11:59');
INSERT INTO `sys_menu` VALUES (2, '用户管理', NULL, '/sysManage/user', 1, 'el-icon-s-custom', 'system/user/index', 1, 0, 1, 1, '2021-06-06 01:15:25', '2021-06-06 01:15:25');
INSERT INTO `sys_menu` VALUES (3, '部门管理', NULL, '/sysManage/dept', 1, 'iconfont icon-bumen', 'system/dept/dept', 1, 0, 1, 1, '2021-06-06 01:22:27', '2021-06-06 01:22:27');
INSERT INTO `sys_menu` VALUES (4, '角色管理', NULL, '/sysManager/role', 1, 'iconfont icon-jiaoseguanli', 'system/role/index', 1, 0, 1, 1, '2021-06-06 01:29:00', '2021-06-06 01:29:00');
INSERT INTO `sys_menu` VALUES (5, '角色管理', NULL, '/sysManager/role', 1, 'iconfont icon-jiaoseguanli', 'system/role/index', 1, 0, -1, 1, '2021-06-06 01:29:15', '2021-06-06 01:29:15');
INSERT INTO `sys_menu` VALUES (6, '菜单管理', NULL, '/sysManage/menu', 1, 'iconfont icon-caidanguanli', 'system/menu/index', 1, 0, 1, 1, '2021-06-06 01:42:43', '2021-06-06 01:42:43');
INSERT INTO `sys_menu` VALUES (7, '个人中心', NULL, '/userCenter', 1, NULL, 'system/user/userCenter/userCenter', 1, 6, 1, 0, '2021-06-06 17:13:47', '2021-06-06 17:13:47');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) DEFAULT NULL,
  `role_desc` varchar(255) DEFAULT NULL,
  `data_status` int(11) DEFAULT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, 'admin', '超级管理员', 1, '2021-06-06 01:44:39', '2021-06-06 01:44:39');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menus_sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menus_sys_menu`;
CREATE TABLE `sys_role_menus_sys_menu` (
  `sysRoleId` int(11) NOT NULL,
  `sysMenuId` int(11) NOT NULL,
  PRIMARY KEY (`sysRoleId`,`sysMenuId`),
  KEY `IDX_e7c90b5f1eae0da649c74cfbcb` (`sysRoleId`),
  KEY `IDX_c6e4b76cb3f4ab1028f2461963` (`sysMenuId`),
  CONSTRAINT `FK_c6e4b76cb3f4ab1028f24619635` FOREIGN KEY (`sysMenuId`) REFERENCES `sys_menu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_e7c90b5f1eae0da649c74cfbcb4` FOREIGN KEY (`sysRoleId`) REFERENCES `sys_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_role_menus_sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menus_sys_menu` VALUES (1, 1);
INSERT INTO `sys_role_menus_sys_menu` VALUES (1, 2);
INSERT INTO `sys_role_menus_sys_menu` VALUES (1, 3);
INSERT INTO `sys_role_menus_sys_menu` VALUES (1, 4);
INSERT INTO `sys_role_menus_sys_menu` VALUES (1, 6);
INSERT INTO `sys_role_menus_sys_menu` VALUES (1, 7);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `avatar` varchar(255) NOT NULL,
  `data_status` int(11) DEFAULT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `deptId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_41e45b2bcc509e4b7ab67fe6bf7` (`deptId`),
  CONSTRAINT `FK_41e45b2bcc509e4b7ab67fe6bf7` FOREIGN KEY (`deptId`) REFERENCES `sys_dept` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', '超级管理员', 'e10adc3949ba59abbe56e057f20f883e', '17178383573', '/uploads/2021-06-06/1622971180035.png', 1, '2021-06-06 00:49:49', '2021-06-08 20:31:05', 3);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_roles_sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_roles_sys_role`;
CREATE TABLE `sys_user_roles_sys_role` (
  `sysUserId` int(11) NOT NULL,
  `sysRoleId` int(11) NOT NULL,
  PRIMARY KEY (`sysUserId`,`sysRoleId`),
  KEY `IDX_d1daac450217c1a1e384e99254` (`sysUserId`),
  KEY `IDX_45602f09af1715f5532db91a43` (`sysRoleId`),
  CONSTRAINT `FK_45602f09af1715f5532db91a43d` FOREIGN KEY (`sysRoleId`) REFERENCES `sys_role` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_d1daac450217c1a1e384e99254a` FOREIGN KEY (`sysUserId`) REFERENCES `sys_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_user_roles_sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_roles_sys_role` VALUES (1, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
